let server=require("express")();
let mysql=require("mysql");
let sql = mysql.createConnection({
	  host     : 'localhost',
	  user     : 'root',
	  password : '123456',
	  database : 'companywebsite'
}); 
server.all("*",function(req,res,next){
				    //设置允许跨域的域名，*代表允许任意域名跨域
				    res.header("Access-Control-Allow-Origin","*");
				    //允许的header类型
				    res.header("Access-Control-Allow-Headers","content-type");
				    //跨域允许的请求方式 
				    res.header("Access-Control-Allow-Methods","DELETE,PUT,POST,GET,OPTIONS");
				    if (req.method.toLowerCase() == 'options')
				        res.send(200);  //让options尝试请求快速结束
				    else
				        next();
				})
server.listen(8080);
// 尝试链接
sql.connect();
server.get("/projectL",function(request,response){
	sql.query(`SELECT*FROM projectlist`,function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.send(JSON.stringify(data));
		console.log("projectL success!!!");
	})
})

server.get("/projectD",function(request,response){
	let id=request.query.id
	sql.query(`SELECT * FROM projectlist WHERE id=${id}`,function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.send(JSON.stringify(data[0]));
		console.log("projectD success!!!");
	})
})

server.get("/solutionL",function(request,response){
	sql.query(`SELECT * FROM solution`,function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.send(JSON.stringify(data));
		console.log("solutionL success!!!");
	})
})
server.get("/solutionD",function(request,response){
	let id=request.query.id
	sql.query(`SELECT * FROM solution WHERE id=${id}`,function(error,data){
		if(error){
			console.log(error);
			response.end("error");
			return;
		}
		response.send(JSON.stringify(data[0]));
		console.log("solutionD success!!!");
	})
})